Paul Newcome
Paul Newcome
-
Re: Help revising IF statement for Business days (NETWORK DAYS) rather than Calendar Days
Try this: =IF(Parent@row <> 1, IF([Certification Complete]@row <> "Green", IF([Workflow Initiated]@row <> "", WORKDAY([Workflow Initiated]@row, 14)))) There is n…1 · -
Re: How to get sheet owner information
If the get_sheet doesn't work for at least retrieving the owner, getting the sheet shares should do the trick.1 · -
Re: Make conditional formatting refresh all source pages for report and dashboard accuracy
You can insert a hidden date type column then use a Record A Date automation set to run daily to record the date in the hidden column. This will force refresh your sheet and in turn solve your issue.1 · -
Re: Error reports
You can create a helper column (I use checkboxes personally) called Error. You can then enter the following formula and dragfill on down. =IF(ISERROR([First Column Name]@row:[Last Column Name]@row), …1 · -
Re: #Incorrect Argument Set
You still haven't closed out your AND functions. They should be closed BEFORE the output. You have IF(AND("this" = "this", "that" = "that", "output")…1 ·
